LESS

The LESS field specifier (case sensitive) allows you to find documents in which a specified field contains a number that is smaller than a specified number.

NOTE: You can optimize the field specifier speed by restricting the field to the NumericType property type.

Format

FieldText=LESS{yourNumber}:yourFields
yourNumber

A number. A document returns only if one of yourFields contains a number that is smaller than this number.

By default, the range is exclusive. You can add an equals sign (=) to include the number that you specify.

yourFields One or more fields. A document returns only if it contains one of these fields, and if the number in this field is smaller than yourNumber. Separate multiple fields with colons (there must be no space before or after a colon).

Example

FieldText=LESS{66}:ID

A document's ID field must contain a smaller number than 66 for this document to be returned.

FieldText=LESS{5.59}:PRICE:PREIS

A document's PRICE or PREIS field must contain a smaller number than 5.59 for this document to be returned.

FieldText=LESS{=6}:QUANTITY

The QUANTITY field must contain a value of 6 or lower for the document to return.